Magnum One/Magnum One (Mid-American Digital) (Disc Manufacturing).iso/d3/db4less3.arc/SQLDEMO.PRS

Text File | 1990-06-16 | 394b | 26 lines

START DATABASE samples;

CLEAR
? "Simple Retrievel:"
SELECT fname, lname
FROM emp;

WAIT
CLEAR
? "Retrieval with Selection and Order:"
SELECT lname,address
FROM emp
WHERE lname > "M"
ORDER BY lname;

WAIT
CLEAR
? "Joining of EMP and EMPRATE then Retrieval:"
SELECT fname,lname, emprate.rate
FROM emp,emprate
WHERE emp.empid=emprate.empid
ORDER BY lname;

WAIT
CLEAR